﻿DROP TABLE IF EXISTS `open_catalog`;
CREATE TABLE `open_catalog` (
  `catalog_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `catalog_sn` varchar(60) NOT NULL DEFAULT '',
  `catalog_name` varchar(255) NOT NULL DEFAULT '',
  `catalog_alias` varchar(255) NOT NULL DEFAULT '',
  `start_time` int(10) unsigned NOT NULL,
  `end_time` int(10) unsigned NOT NULL,
  `catalog_desc` text NOT NULL,
  `catalog_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`catalog_id`),
  UNIQUE KEY `catalog_sn` (`catalog_sn`),
  KEY `catalog_status` (`catalog_status`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;